package com.noahplat.fourg.mapper;

import com.noahplat.datapro.pojo.Sp;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

/**
 * 功能：设备状态mapper
 * name：宋彦磊
 * time：2021.02.25
 */

public interface SpMapper extends Mapper<Sp> {
    @Insert("INSERT INTO sp VALUES (#{ts}, #{imei},#{sp},#{model},#{type},#{prod})")
    int insertImei(Sp sp);
    @Select("SELECT imei as imei,sp as sp,type as type,prod as prod,model as model,ts as ts FROM sp WHERE imei=#{imei}")
    Sp selectImei(@Param("imei") String imei);
}
